package com.intco.ait.quotation.api.infrastructure.mybatis.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.intco.ait.quotation.api.infrastructure.mybatis.entity.encodingPlatform.InventoryMoulding;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@DS("sd-mrp")
public interface SdMrpMapper {

    @Select({
            "SELECT ",
            "InvCode AS invCode,",
            "DeclarationType AS declareFlag,",
            "MouldingSID AS mouldId,",
            "MouldingStyleType AS mouldType,",
            "MouldingStyleMethod AS cuttingMode,",
            "MouldingStyleCode AS mouldCode,",
            "MouldingStyleSize AS innerDiameterSize,",
            "MouldingQuantity AS quantity,",
            "PrCuttingMethod as prCuttingMethod",
            "FROM BD_InventoryMoulding",
            "WHERE InvCode=#{invCode}"
    })
    List<InventoryMoulding> getListByInvCode(String invCode);

}
